Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL Tutorial
1) Aggregate Functions
2) Cast Functions Operators
3) Comparison Functions Operators
4) Control Flow Functions
5) Cursor
6) Data Dictionary
7) Data Types
8) Database
9) Date Time Functions
10) Encryption Compression Functions
11) Information Functions
12) Insert Update Delete
13) Introduction
14) Logic Operator
15) Math Numeric Functions
16) Miscellaneous Functions
17) MySQL Utilities
18) Privilege
19) Procedure Function
20) Regular Expressions
21) Select Query
22) String Functions
23) Subquery
24) Table
25) Table Join
26) Trigger
27) View

Aggregate Functions
1) A SUM() function can be added to CASE statement to give us the total
2) Aggregate Functions
3) AVG with NULL value
4) AVG() can work out more that one value at a time when used with a GROUP BY clause
5) AVG() can work with a join
6) AVG() can work with other functions
7) AVG([DISTINCT] expr)
8) Count()
9) COUNT(column name)
10) COUNT(DISTINCT expr,[expr ]) (Returns a count of the number of different non-NULL values )
11) Distinct count
12) Get the average of a set of sums for a grouped table
13) GROUP_CONCAT(expr) returns a string result with the concatenated non-NULL values from a group
14) MAX function with date value
15) MAX function with number value
16) MAX function with text value
17) Maximum of Column per Group
18) MIN function and number value
19) MIN function with date value
20) MIN function with text value
21) Return the total number of rows
22) STD function with NULL value
23) STD(expr)STDDEV(expr) returns the population standard deviation of expr
24) STDDEV_POP(expr) returns the population standard deviation of expr (the square root of VAR_POP())
25) STDDEV_SAMP(expr) returns the sample standard deviation of expr (the square root of VAR_SAMP()
26) SUM function with column calculation
27) SUM with NULL value
28) SUM() function totals the values in a given column
29) The STD() function returns the standard deviation of a given column
30) The SUM() and AVG() aggregate functions do not work with temporal values
31) Use aggregate function with group by clause
32) Use and IF() and COUNT() to give us a total as COUNT() ignores NULL values
33) Use two aggregate functions in a select statement
34) Using COUNT() in a table JOIN
35) Using SUM([DISTINCT] expr) function to sum the salary
36) VAR_POP(expr) returns the population standard variance of expr
37) VAR_SAMP(expr) returns the sample variance of expr
38) VARIANCE(expr) returns the population standard variance of expr